# coding: utf-8
from application import db
from common.models.user import User


class SalaryDed(db.Model):
    __tablename__ = 'salary_ded'

    id = db.Column(db.Integer, primary_key=True)

    userid = db.Column(db.Integer)
    child = db.Column(db.Float)
    parent = db.Column(db.Float)
    house = db.Column(db.Float)
    rent = db.Column(db.Float)
    sick = db.Column(db.Float)
    study = db.Column(db.Float)
    lilchirdfund = db.Column(db.Float)

    year = db.Column(db.Integer)

    updated_time = db.Column(db.DateTime)
    created_time = db.Column(db.DateTime)





